<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<meta name="generator" content="Doxygen 1.8.6"/>
<title>SystemSharp: SQLiteAsync.cs Source File</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="navtree.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="resize.js"></script>
<script type="text/javascript" src="navtree.js"></script>
<script type="text/javascript">
  $(document).ready(initResizable);
  $(window).load(resizeHeight);
</script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/search.js"></script>
<script type="text/javascript">
  $(document).ready(function() { searchBox.OnSelectItem(0); });
</script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  <td id="projectlogo"><img alt="Logo" src="logo.png"/></td>
  <td style="padding-left: 0.5em;">
   <div id="projectname">SystemSharp
   &#160;<span id="projectnumber">0.3</span>
   </div>
   <div id="projectbrief">A system-level modeling framework for designing real-time embedded systems</div>
  </td>
 </tr>
 </tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.8.6 -->
<script type="text/javascript">
var searchBox = new SearchBox("searchBox", "search",false,'Search');
</script>
  <div id="navrow1" class="tabs">
    <ul class="tablist">
      <li><a href="index.html"><span>Main&#160;Page</span></a></li>
      <li><a href="namespaces.html"><span>Packages</span></a></li>
      <li><a href="annotated.html"><span>Classes</span></a></li>
      <li class="current"><a href="files.html"><span>Files</span></a></li>
      <li>
        <div id="MSearchBox" class="MSearchBoxInactive">
        <span class="left">
          <img id="MSearchSelect" src="search/mag_sel.png"
               onmouseover="return searchBox.OnSearchSelectShow()"
               onmouseout="return searchBox.OnSearchSelectHide()"
               alt=""/>
          <input type="text" id="MSearchField" value="Search" accesskey="S"
               onfocus="searchBox.OnSearchFieldFocus(true)" 
               onblur="searchBox.OnSearchFieldFocus(false)" 
               onkeyup="searchBox.OnSearchFieldChange(event)"/>
          </span><span class="right">
            <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a>
          </span>
        </div>
      </li>
    </ul>
  </div>
  <div id="navrow2" class="tabs2">
    <ul class="tablist">
      <li><a href="files.html"><span>File&#160;List</span></a></li>
      <li><a href="globals.html"><span>File&#160;Members</span></a></li>
    </ul>
  </div>
</div><!-- top -->
<div id="side-nav" class="ui-resizable side-nav-resizable">
  <div id="nav-tree">
    <div id="nav-tree-contents">
      <div id="nav-sync" class="sync"></div>
    </div>
  </div>
  <div id="splitbar" style="-moz-user-select:none;" 
       class="ui-resizable-handle">
  </div>
</div>
<script type="text/javascript">
$(document).ready(function(){initNavTree('_s_q_lite_async_8cs_source.html','');});
</script>
<div id="doc-content">
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
<a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark">&#160;</span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark">&#160;</span>Classes</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark">&#160;</span>Namespaces</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark">&#160;</span>Files</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark">&#160;</span>Functions</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(5)"><span class="SelectionMark">&#160;</span>Variables</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(6)"><span class="SelectionMark">&#160;</span>Typedefs</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(7)"><span class="SelectionMark">&#160;</span>Enumerations</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(8)"><span class="SelectionMark">&#160;</span>Enumerator</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(9)"><span class="SelectionMark">&#160;</span>Properties</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(10)"><span class="SelectionMark">&#160;</span>Events</a></div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>

<div class="header">
  <div class="headertitle">
<div class="title">SQLiteAsync.cs</div>  </div>
</div><!--header-->
<div class="contents">
<a href="_s_q_lite_async_8cs.html">Go to the documentation of this file.</a><div class="fragment"><div class="line"><a name="l00001"></a><span class="lineno">    1</span>&#160;<span class="comment">//</span></div>
<div class="line"><a name="l00002"></a><span class="lineno">    2</span>&#160;<span class="comment">// Copyright (c) 2012 Krueger Systems, Inc.</span></div>
<div class="line"><a name="l00003"></a><span class="lineno">    3</span>&#160;<span class="comment">// </span></div>
<div class="line"><a name="l00004"></a><span class="lineno">    4</span>&#160;<span class="comment">// Permission is hereby granted, free of charge, to any person obtaining a copy</span></div>
<div class="line"><a name="l00005"></a><span class="lineno">    5</span>&#160;<span class="comment">// of this software and associated documentation files (the &quot;Software&quot;), to deal</span></div>
<div class="line"><a name="l00006"></a><span class="lineno">    6</span>&#160;<span class="comment">// in the Software without restriction, including without limitation the rights</span></div>
<div class="line"><a name="l00007"></a><span class="lineno">    7</span>&#160;<span class="comment">// to use, copy, modify, merge, publish, distribute, sublicense, and/or sell</span></div>
<div class="line"><a name="l00008"></a><span class="lineno">    8</span>&#160;<span class="comment">// copies of the Software, and to permit persons to whom the Software is</span></div>
<div class="line"><a name="l00009"></a><span class="lineno">    9</span>&#160;<span class="comment">// furnished to do so, subject to the following conditions:</span></div>
<div class="line"><a name="l00010"></a><span class="lineno">   10</span>&#160;<span class="comment">// </span></div>
<div class="line"><a name="l00011"></a><span class="lineno">   11</span>&#160;<span class="comment">// The above copyright notice and this permission notice shall be included in</span></div>
<div class="line"><a name="l00012"></a><span class="lineno">   12</span>&#160;<span class="comment">// all copies or substantial portions of the Software.</span></div>
<div class="line"><a name="l00013"></a><span class="lineno">   13</span>&#160;<span class="comment">// </span></div>
<div class="line"><a name="l00014"></a><span class="lineno">   14</span>&#160;<span class="comment">// THE SOFTWARE IS PROVIDED &quot;AS IS&quot;, WITHOUT WARRANTY OF ANY KIND, EXPRESS OR</span></div>
<div class="line"><a name="l00015"></a><span class="lineno">   15</span>&#160;<span class="comment">// IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,</span></div>
<div class="line"><a name="l00016"></a><span class="lineno">   16</span>&#160;<span class="comment">// FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE</span></div>
<div class="line"><a name="l00017"></a><span class="lineno">   17</span>&#160;<span class="comment">// AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER</span></div>
<div class="line"><a name="l00018"></a><span class="lineno">   18</span>&#160;<span class="comment">// LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,</span></div>
<div class="line"><a name="l00019"></a><span class="lineno">   19</span>&#160;<span class="comment">// OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN</span></div>
<div class="line"><a name="l00020"></a><span class="lineno">   20</span>&#160;<span class="comment">// THE SOFTWARE.</span></div>
<div class="line"><a name="l00021"></a><span class="lineno">   21</span>&#160;<span class="comment">//</span></div>
<div class="line"><a name="l00022"></a><span class="lineno">   22</span>&#160;</div>
<div class="line"><a name="l00023"></a><span class="lineno">   23</span>&#160;<span class="keyword">using</span> System;</div>
<div class="line"><a name="l00024"></a><span class="lineno">   24</span>&#160;<span class="keyword">using</span> System.Collections;</div>
<div class="line"><a name="l00025"></a><span class="lineno">   25</span>&#160;<span class="keyword">using</span> System.Collections.Generic;</div>
<div class="line"><a name="l00026"></a><span class="lineno">   26</span>&#160;<span class="keyword">using</span> System.Linq;</div>
<div class="line"><a name="l00027"></a><span class="lineno">   27</span>&#160;<span class="keyword">using</span> System.Linq.Expressions;</div>
<div class="line"><a name="l00028"></a><span class="lineno">   28</span>&#160;<span class="keyword">using</span> System.Threading;</div>
<div class="line"><a name="l00029"></a><span class="lineno">   29</span>&#160;<span class="keyword">using</span> System.Threading.Tasks;</div>
<div class="line"><a name="l00030"></a><span class="lineno">   30</span>&#160;</div>
<div class="line"><a name="l00031"></a><span class="lineno">   31</span>&#160;<span class="keyword">namespace </span>SQLite</div>
<div class="line"><a name="l00032"></a><span class="lineno">   32</span>&#160;{</div>
<div class="line"><a name="l00033"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_async_connection.html">   33</a></span>&#160;    <span class="keyword">public</span> <span class="keyword">partial class </span><a class="code" href="class_s_q_lite_1_1_s_q_lite_async_connection.html">SQLiteAsyncConnection</a></div>
<div class="line"><a name="l00034"></a><span class="lineno">   34</span>&#160;    {</div>
<div class="line"><a name="l00035"></a><span class="lineno">   35</span>&#160;        <a class="code" href="class_s_q_lite_1_1_s_q_lite_connection_string.html">SQLiteConnectionString</a> _connectionString;</div>
<div class="line"><a name="l00036"></a><span class="lineno">   36</span>&#160;</div>
<div class="line"><a name="l00037"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a6b26a70d833ede366339dcdf0ac4ddec">   37</a></span>&#160;        <span class="keyword">public</span> <a class="code" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a6b26a70d833ede366339dcdf0ac4ddec">SQLiteAsyncConnection</a> (<span class="keywordtype">string</span> databasePath, <span class="keywordtype">bool</span> storeDateTimeAsTicks = <span class="keyword">false</span>)</div>
<div class="line"><a name="l00038"></a><span class="lineno">   38</span>&#160;        {</div>
<div class="line"><a name="l00039"></a><span class="lineno">   39</span>&#160;            _connectionString = <span class="keyword">new</span> <a class="code" href="class_s_q_lite_1_1_s_q_lite_connection_string.html">SQLiteConnectionString</a> (databasePath, storeDateTimeAsTicks);</div>
<div class="line"><a name="l00040"></a><span class="lineno">   40</span>&#160;        }</div>
<div class="line"><a name="l00041"></a><span class="lineno">   41</span>&#160;</div>
<div class="line"><a name="l00042"></a><span class="lineno">   42</span>&#160;        <a class="code" href="class_s_q_lite_1_1_s_q_lite_connection_with_lock.html">SQLiteConnectionWithLock</a> GetConnection ()</div>
<div class="line"><a name="l00043"></a><span class="lineno">   43</span>&#160;        {</div>
<div class="line"><a name="l00044"></a><span class="lineno">   44</span>&#160;            <span class="keywordflow">return</span> SQLiteConnectionPool.Shared.GetConnection (_connectionString);</div>
<div class="line"><a name="l00045"></a><span class="lineno">   45</span>&#160;        }</div>
<div class="line"><a name="l00046"></a><span class="lineno">   46</span>&#160;</div>
<div class="line"><a name="l00047"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a120dc02c80780a01f9158aa2dc4110e3">   47</a></span>&#160;        <span class="keyword">public</span> Task&lt;CreateTablesResult&gt; <a class="code" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a120dc02c80780a01f9158aa2dc4110e3">CreateTableAsync&lt;T&gt;</a> ()</div>
<div class="line"><a name="l00048"></a><span class="lineno">   48</span>&#160;            where T : <span class="keyword">new</span> ()</div>
<div class="line"><a name="l00049"></a><span class="lineno">   49</span>&#160;        {</div>
<div class="line"><a name="l00050"></a><span class="lineno">   50</span>&#160;            <span class="keywordflow">return</span> <a class="code" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#af98ef3fd9628a9cda7b2b0532291f04b">CreateTablesAsync</a> (typeof (T));</div>
<div class="line"><a name="l00051"></a><span class="lineno">   51</span>&#160;        }</div>
<div class="line"><a name="l00052"></a><span class="lineno">   52</span>&#160;</div>
<div class="line"><a name="l00053"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a1911c2250387bf7db96a05d4ab73bfe7">   53</a></span>&#160;        <span class="keyword">public</span> Task&lt;CreateTablesResult&gt; <a class="code" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a1911c2250387bf7db96a05d4ab73bfe7">CreateTablesAsync&lt;T, T2&gt;</a> ()</div>
<div class="line"><a name="l00054"></a><span class="lineno">   54</span>&#160;            where T : <span class="keyword">new</span> ()</div>
<div class="line"><a name="l00055"></a><span class="lineno">   55</span>&#160;            where T2 : new ()</div>
<div class="line"><a name="l00056"></a><span class="lineno">   56</span>&#160;        {</div>
<div class="line"><a name="l00057"></a><span class="lineno">   57</span>&#160;            <span class="keywordflow">return</span> <a class="code" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#af98ef3fd9628a9cda7b2b0532291f04b">CreateTablesAsync</a> (typeof (T), typeof (T2));</div>
<div class="line"><a name="l00058"></a><span class="lineno">   58</span>&#160;        }</div>
<div class="line"><a name="l00059"></a><span class="lineno">   59</span>&#160;</div>
<div class="line"><a name="l00060"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a0d18028757d84c1d5ef6b4f0a2f31bf8">   60</a></span>&#160;        <span class="keyword">public</span> Task&lt;CreateTablesResult&gt; <a class="code" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a0d18028757d84c1d5ef6b4f0a2f31bf8">CreateTablesAsync&lt;T, T2, T3&gt;</a> ()</div>
<div class="line"><a name="l00061"></a><span class="lineno">   61</span>&#160;            where T : <span class="keyword">new</span> ()</div>
<div class="line"><a name="l00062"></a><span class="lineno">   62</span>&#160;            where T2 : new ()</div>
<div class="line"><a name="l00063"></a><span class="lineno">   63</span>&#160;            where T3 : new ()</div>
<div class="line"><a name="l00064"></a><span class="lineno">   64</span>&#160;        {</div>
<div class="line"><a name="l00065"></a><span class="lineno">   65</span>&#160;            <span class="keywordflow">return</span> <a class="code" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#af98ef3fd9628a9cda7b2b0532291f04b">CreateTablesAsync</a> (typeof (T), typeof (T2), typeof (T3));</div>
<div class="line"><a name="l00066"></a><span class="lineno">   66</span>&#160;        }</div>
<div class="line"><a name="l00067"></a><span class="lineno">   67</span>&#160;</div>
<div class="line"><a name="l00068"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a36ed358566d4c64e0bf524c7d8c681a4">   68</a></span>&#160;        <span class="keyword">public</span> Task&lt;CreateTablesResult&gt; <a class="code" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a36ed358566d4c64e0bf524c7d8c681a4">CreateTablesAsync&lt;T, T2, T3, T4&gt;</a> ()</div>
<div class="line"><a name="l00069"></a><span class="lineno">   69</span>&#160;            where T : <span class="keyword">new</span> ()</div>
<div class="line"><a name="l00070"></a><span class="lineno">   70</span>&#160;            where T2 : new ()</div>
<div class="line"><a name="l00071"></a><span class="lineno">   71</span>&#160;            where T3 : new ()</div>
<div class="line"><a name="l00072"></a><span class="lineno">   72</span>&#160;            where T4 : new ()</div>
<div class="line"><a name="l00073"></a><span class="lineno">   73</span>&#160;        {</div>
<div class="line"><a name="l00074"></a><span class="lineno">   74</span>&#160;            <span class="keywordflow">return</span> <a class="code" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#af98ef3fd9628a9cda7b2b0532291f04b">CreateTablesAsync</a> (typeof (T), typeof (T2), typeof (T3), typeof (T4));</div>
<div class="line"><a name="l00075"></a><span class="lineno">   75</span>&#160;        }</div>
<div class="line"><a name="l00076"></a><span class="lineno">   76</span>&#160;</div>
<div class="line"><a name="l00077"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a9b3c8584432d04508c89aebbbb1fedea">   77</a></span>&#160;        <span class="keyword">public</span> Task&lt;CreateTablesResult&gt; <a class="code" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a9b3c8584432d04508c89aebbbb1fedea">CreateTablesAsync&lt;T, T2, T3, T4, T5&gt;</a> ()</div>
<div class="line"><a name="l00078"></a><span class="lineno">   78</span>&#160;            where T : <span class="keyword">new</span> ()</div>
<div class="line"><a name="l00079"></a><span class="lineno">   79</span>&#160;            where T2 : new ()</div>
<div class="line"><a name="l00080"></a><span class="lineno">   80</span>&#160;            where T3 : new ()</div>
<div class="line"><a name="l00081"></a><span class="lineno">   81</span>&#160;            where T4 : new ()</div>
<div class="line"><a name="l00082"></a><span class="lineno">   82</span>&#160;            where T5 : new ()</div>
<div class="line"><a name="l00083"></a><span class="lineno">   83</span>&#160;        {</div>
<div class="line"><a name="l00084"></a><span class="lineno">   84</span>&#160;            <span class="keywordflow">return</span> <a class="code" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#af98ef3fd9628a9cda7b2b0532291f04b">CreateTablesAsync</a> (typeof (T), typeof (T2), typeof (T3), typeof (T4), typeof (T5));</div>
<div class="line"><a name="l00085"></a><span class="lineno">   85</span>&#160;        }</div>
<div class="line"><a name="l00086"></a><span class="lineno">   86</span>&#160;</div>
<div class="line"><a name="l00087"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#af98ef3fd9628a9cda7b2b0532291f04b">   87</a></span>&#160;        <span class="keyword">public</span> Task&lt;CreateTablesResult&gt; <a class="code" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#af98ef3fd9628a9cda7b2b0532291f04b">CreateTablesAsync</a> (params Type[] types)</div>
<div class="line"><a name="l00088"></a><span class="lineno">   88</span>&#160;        {</div>
<div class="line"><a name="l00089"></a><span class="lineno">   89</span>&#160;            <span class="keywordflow">return</span> Task.Factory.StartNew (() =&gt; {</div>
<div class="line"><a name="l00090"></a><span class="lineno">   90</span>&#160;                <a class="code" href="class_s_q_lite_1_1_create_tables_result.html">CreateTablesResult</a> result = <span class="keyword">new</span> <a class="code" href="class_s_q_lite_1_1_create_tables_result.html">CreateTablesResult</a> ();</div>
<div class="line"><a name="l00091"></a><span class="lineno">   91</span>&#160;                var conn = GetConnection ();</div>
<div class="line"><a name="l00092"></a><span class="lineno">   92</span>&#160;                <span class="keyword">using</span> (conn.Lock ()) {</div>
<div class="line"><a name="l00093"></a><span class="lineno">   93</span>&#160;                    <span class="keywordflow">foreach</span> (Type type <span class="keywordflow">in</span> types) {</div>
<div class="line"><a name="l00094"></a><span class="lineno">   94</span>&#160;                        <span class="keywordtype">int</span> aResult = conn.CreateTable (type);</div>
<div class="line"><a name="l00095"></a><span class="lineno">   95</span>&#160;                        result.Results[type] = aResult;</div>
<div class="line"><a name="l00096"></a><span class="lineno">   96</span>&#160;                    }</div>
<div class="line"><a name="l00097"></a><span class="lineno">   97</span>&#160;                }</div>
<div class="line"><a name="l00098"></a><span class="lineno">   98</span>&#160;                <span class="keywordflow">return</span> result;</div>
<div class="line"><a name="l00099"></a><span class="lineno">   99</span>&#160;            });</div>
<div class="line"><a name="l00100"></a><span class="lineno">  100</span>&#160;        }</div>
<div class="line"><a name="l00101"></a><span class="lineno">  101</span>&#160;</div>
<div class="line"><a name="l00102"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a6781339fb664cde6494460e686f5cb60">  102</a></span>&#160;        <span class="keyword">public</span> Task&lt;int&gt; <a class="code" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a6781339fb664cde6494460e686f5cb60">DropTableAsync&lt;T&gt;</a> ()</div>
<div class="line"><a name="l00103"></a><span class="lineno">  103</span>&#160;            where T : <span class="keyword">new</span> ()</div>
<div class="line"><a name="l00104"></a><span class="lineno">  104</span>&#160;        {</div>
<div class="line"><a name="l00105"></a><span class="lineno">  105</span>&#160;            <span class="keywordflow">return</span> Task.Factory.StartNew (() =&gt; {</div>
<div class="line"><a name="l00106"></a><span class="lineno">  106</span>&#160;                var conn = GetConnection ();</div>
<div class="line"><a name="l00107"></a><span class="lineno">  107</span>&#160;                <span class="keyword">using</span> (conn.Lock ()) {</div>
<div class="line"><a name="l00108"></a><span class="lineno">  108</span>&#160;                    <span class="keywordflow">return</span> conn.DropTable&lt;T&gt; ();</div>
<div class="line"><a name="l00109"></a><span class="lineno">  109</span>&#160;                }</div>
<div class="line"><a name="l00110"></a><span class="lineno">  110</span>&#160;            });</div>
<div class="line"><a name="l00111"></a><span class="lineno">  111</span>&#160;        }</div>
<div class="line"><a name="l00112"></a><span class="lineno">  112</span>&#160;</div>
<div class="line"><a name="l00113"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a7c621805c4f3185e9b064288b2b47d4a">  113</a></span>&#160;        <span class="keyword">public</span> Task&lt;int&gt; <a class="code" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a7c621805c4f3185e9b064288b2b47d4a">InsertAsync</a> (<span class="keywordtype">object</span> item)</div>
<div class="line"><a name="l00114"></a><span class="lineno">  114</span>&#160;        {</div>
<div class="line"><a name="l00115"></a><span class="lineno">  115</span>&#160;            <span class="keywordflow">return</span> Task.Factory.StartNew (() =&gt; {</div>
<div class="line"><a name="l00116"></a><span class="lineno">  116</span>&#160;                var conn = GetConnection ();</div>
<div class="line"><a name="l00117"></a><span class="lineno">  117</span>&#160;                <span class="keyword">using</span> (conn.Lock ()) {</div>
<div class="line"><a name="l00118"></a><span class="lineno">  118</span>&#160;                    <span class="keywordflow">return</span> conn.Insert (item);</div>
<div class="line"><a name="l00119"></a><span class="lineno">  119</span>&#160;                }</div>
<div class="line"><a name="l00120"></a><span class="lineno">  120</span>&#160;            });</div>
<div class="line"><a name="l00121"></a><span class="lineno">  121</span>&#160;        }</div>
<div class="line"><a name="l00122"></a><span class="lineno">  122</span>&#160;</div>
<div class="line"><a name="l00123"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a3950c4feb7a8d2964a42167d8a4516a0">  123</a></span>&#160;        <span class="keyword">public</span> Task&lt;int&gt; <a class="code" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a3950c4feb7a8d2964a42167d8a4516a0">UpdateAsync</a> (<span class="keywordtype">object</span> item)</div>
<div class="line"><a name="l00124"></a><span class="lineno">  124</span>&#160;        {</div>
<div class="line"><a name="l00125"></a><span class="lineno">  125</span>&#160;            <span class="keywordflow">return</span> Task.Factory.StartNew (() =&gt; {</div>
<div class="line"><a name="l00126"></a><span class="lineno">  126</span>&#160;                var conn = GetConnection ();</div>
<div class="line"><a name="l00127"></a><span class="lineno">  127</span>&#160;                <span class="keyword">using</span> (conn.Lock ()) {</div>
<div class="line"><a name="l00128"></a><span class="lineno">  128</span>&#160;                    <span class="keywordflow">return</span> conn.Update (item);</div>
<div class="line"><a name="l00129"></a><span class="lineno">  129</span>&#160;                }</div>
<div class="line"><a name="l00130"></a><span class="lineno">  130</span>&#160;            });</div>
<div class="line"><a name="l00131"></a><span class="lineno">  131</span>&#160;        }</div>
<div class="line"><a name="l00132"></a><span class="lineno">  132</span>&#160;</div>
<div class="line"><a name="l00133"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#ac34ee6c331f35dc8cbb73a0373315fb0">  133</a></span>&#160;        <span class="keyword">public</span> Task&lt;int&gt; <a class="code" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#ac34ee6c331f35dc8cbb73a0373315fb0">DeleteAsync</a> (<span class="keywordtype">object</span> item)</div>
<div class="line"><a name="l00134"></a><span class="lineno">  134</span>&#160;        {</div>
<div class="line"><a name="l00135"></a><span class="lineno">  135</span>&#160;            <span class="keywordflow">return</span> Task.Factory.StartNew (() =&gt; {</div>
<div class="line"><a name="l00136"></a><span class="lineno">  136</span>&#160;                var conn = GetConnection ();</div>
<div class="line"><a name="l00137"></a><span class="lineno">  137</span>&#160;                <span class="keyword">using</span> (conn.Lock ()) {</div>
<div class="line"><a name="l00138"></a><span class="lineno">  138</span>&#160;                    <span class="keywordflow">return</span> conn.Delete (item);</div>
<div class="line"><a name="l00139"></a><span class="lineno">  139</span>&#160;                }</div>
<div class="line"><a name="l00140"></a><span class="lineno">  140</span>&#160;            });</div>
<div class="line"><a name="l00141"></a><span class="lineno">  141</span>&#160;        }</div>
<div class="line"><a name="l00142"></a><span class="lineno">  142</span>&#160;</div>
<div class="line"><a name="l00143"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a59792569de902bd2e87b967a35154d4c">  143</a></span>&#160;        <span class="keyword">public</span> Task&lt;T&gt; <a class="code" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a59792569de902bd2e87b967a35154d4c">GetAsync&lt;T&gt;</a>(<span class="keywordtype">object</span> pk)</div>
<div class="line"><a name="l00144"></a><span class="lineno">  144</span>&#160;            where T : <span class="keyword">new</span>()</div>
<div class="line"><a name="l00145"></a><span class="lineno">  145</span>&#160;        {</div>
<div class="line"><a name="l00146"></a><span class="lineno">  146</span>&#160;            <span class="keywordflow">return</span> Task.Factory.StartNew(() =&gt;</div>
<div class="line"><a name="l00147"></a><span class="lineno">  147</span>&#160;            {</div>
<div class="line"><a name="l00148"></a><span class="lineno">  148</span>&#160;                var conn = GetConnection();</div>
<div class="line"><a name="l00149"></a><span class="lineno">  149</span>&#160;                <span class="keyword">using</span> (conn.Lock())</div>
<div class="line"><a name="l00150"></a><span class="lineno">  150</span>&#160;                {</div>
<div class="line"><a name="l00151"></a><span class="lineno">  151</span>&#160;                    <span class="keywordflow">return</span> conn.Get&lt;T&gt;(pk);</div>
<div class="line"><a name="l00152"></a><span class="lineno">  152</span>&#160;                }</div>
<div class="line"><a name="l00153"></a><span class="lineno">  153</span>&#160;            });</div>
<div class="line"><a name="l00154"></a><span class="lineno">  154</span>&#160;        }</div>
<div class="line"><a name="l00155"></a><span class="lineno">  155</span>&#160;</div>
<div class="line"><a name="l00156"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a4e09e6aacf646853516ab1befea4ac4b">  156</a></span>&#160;        <span class="keyword">public</span> Task&lt;T&gt; <a class="code" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a4e09e6aacf646853516ab1befea4ac4b">FindAsync&lt;T&gt;</a> (<span class="keywordtype">object</span> pk)</div>
<div class="line"><a name="l00157"></a><span class="lineno">  157</span>&#160;            where T : <span class="keyword">new</span> ()</div>
<div class="line"><a name="l00158"></a><span class="lineno">  158</span>&#160;        {</div>
<div class="line"><a name="l00159"></a><span class="lineno">  159</span>&#160;            <span class="keywordflow">return</span> Task.Factory.StartNew (() =&gt; {</div>
<div class="line"><a name="l00160"></a><span class="lineno">  160</span>&#160;                var conn = GetConnection ();</div>
<div class="line"><a name="l00161"></a><span class="lineno">  161</span>&#160;                <span class="keyword">using</span> (conn.Lock ()) {</div>
<div class="line"><a name="l00162"></a><span class="lineno">  162</span>&#160;                    <span class="keywordflow">return</span> conn.Find&lt;T&gt; (pk);</div>
<div class="line"><a name="l00163"></a><span class="lineno">  163</span>&#160;                }</div>
<div class="line"><a name="l00164"></a><span class="lineno">  164</span>&#160;            });</div>
<div class="line"><a name="l00165"></a><span class="lineno">  165</span>&#160;        }</div>
<div class="line"><a name="l00166"></a><span class="lineno">  166</span>&#160;        </div>
<div class="line"><a name="l00167"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#ad3e092c3fee0a61611570e8e86dbb88e">  167</a></span>&#160;        <span class="keyword">public</span> Task&lt;T&gt; <a class="code" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a59792569de902bd2e87b967a35154d4c">GetAsync&lt;T&gt;</a> (Expression&lt;Func&lt;T, bool&gt;&gt; predicate)</div>
<div class="line"><a name="l00168"></a><span class="lineno">  168</span>&#160;            where T : <span class="keyword">new</span>()</div>
<div class="line"><a name="l00169"></a><span class="lineno">  169</span>&#160;        {</div>
<div class="line"><a name="l00170"></a><span class="lineno">  170</span>&#160;            <span class="keywordflow">return</span> Task.Factory.StartNew(() =&gt;</div>
<div class="line"><a name="l00171"></a><span class="lineno">  171</span>&#160;            {</div>
<div class="line"><a name="l00172"></a><span class="lineno">  172</span>&#160;                var conn = GetConnection();</div>
<div class="line"><a name="l00173"></a><span class="lineno">  173</span>&#160;                <span class="keyword">using</span> (conn.Lock())</div>
<div class="line"><a name="l00174"></a><span class="lineno">  174</span>&#160;                {</div>
<div class="line"><a name="l00175"></a><span class="lineno">  175</span>&#160;                    <span class="keywordflow">return</span> conn.Get&lt;T&gt; (predicate);</div>
<div class="line"><a name="l00176"></a><span class="lineno">  176</span>&#160;                }</div>
<div class="line"><a name="l00177"></a><span class="lineno">  177</span>&#160;            });</div>
<div class="line"><a name="l00178"></a><span class="lineno">  178</span>&#160;        }</div>
<div class="line"><a name="l00179"></a><span class="lineno">  179</span>&#160;</div>
<div class="line"><a name="l00180"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#ab3ee9b32ac49766e4ac20fa697e91f99">  180</a></span>&#160;        <span class="keyword">public</span> Task&lt;T&gt; <a class="code" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a4e09e6aacf646853516ab1befea4ac4b">FindAsync&lt;T&gt;</a> (Expression&lt;Func&lt;T, bool&gt;&gt; predicate)</div>
<div class="line"><a name="l00181"></a><span class="lineno">  181</span>&#160;            where T : <span class="keyword">new</span> ()</div>
<div class="line"><a name="l00182"></a><span class="lineno">  182</span>&#160;        {</div>
<div class="line"><a name="l00183"></a><span class="lineno">  183</span>&#160;            <span class="keywordflow">return</span> Task.Factory.StartNew (() =&gt; {</div>
<div class="line"><a name="l00184"></a><span class="lineno">  184</span>&#160;                var conn = GetConnection ();</div>
<div class="line"><a name="l00185"></a><span class="lineno">  185</span>&#160;                <span class="keyword">using</span> (conn.Lock ()) {</div>
<div class="line"><a name="l00186"></a><span class="lineno">  186</span>&#160;                    <span class="keywordflow">return</span> conn.Find&lt;T&gt; (predicate);</div>
<div class="line"><a name="l00187"></a><span class="lineno">  187</span>&#160;                }</div>
<div class="line"><a name="l00188"></a><span class="lineno">  188</span>&#160;            });</div>
<div class="line"><a name="l00189"></a><span class="lineno">  189</span>&#160;        }</div>
<div class="line"><a name="l00190"></a><span class="lineno">  190</span>&#160;</div>
<div class="line"><a name="l00191"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#aa61f9b65944e23c32cac8b0e2c39d597">  191</a></span>&#160;        <span class="keyword">public</span> Task&lt;int&gt; <a class="code" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#aa61f9b65944e23c32cac8b0e2c39d597">ExecuteAsync</a> (<span class="keywordtype">string</span> query, params <span class="keywordtype">object</span>[] args)</div>
<div class="line"><a name="l00192"></a><span class="lineno">  192</span>&#160;        {</div>
<div class="line"><a name="l00193"></a><span class="lineno">  193</span>&#160;            <span class="keywordflow">return</span> Task&lt;int&gt;.Factory.StartNew (() =&gt; {</div>
<div class="line"><a name="l00194"></a><span class="lineno">  194</span>&#160;                var conn = GetConnection ();</div>
<div class="line"><a name="l00195"></a><span class="lineno">  195</span>&#160;                <span class="keyword">using</span> (conn.Lock ()) {</div>
<div class="line"><a name="l00196"></a><span class="lineno">  196</span>&#160;                    <span class="keywordflow">return</span> conn.Execute (query, args);</div>
<div class="line"><a name="l00197"></a><span class="lineno">  197</span>&#160;                }</div>
<div class="line"><a name="l00198"></a><span class="lineno">  198</span>&#160;            });</div>
<div class="line"><a name="l00199"></a><span class="lineno">  199</span>&#160;        }</div>
<div class="line"><a name="l00200"></a><span class="lineno">  200</span>&#160;</div>
<div class="line"><a name="l00201"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a8caf48d01bf96785143e71ee6a12b6a0">  201</a></span>&#160;        <span class="keyword">public</span> Task&lt;int&gt; <a class="code" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a8caf48d01bf96785143e71ee6a12b6a0">InsertAllAsync</a> (IEnumerable items)</div>
<div class="line"><a name="l00202"></a><span class="lineno">  202</span>&#160;        {</div>
<div class="line"><a name="l00203"></a><span class="lineno">  203</span>&#160;            <span class="keywordflow">return</span> Task.Factory.StartNew (() =&gt; {</div>
<div class="line"><a name="l00204"></a><span class="lineno">  204</span>&#160;                var conn = GetConnection ();</div>
<div class="line"><a name="l00205"></a><span class="lineno">  205</span>&#160;                <span class="keyword">using</span> (conn.Lock ()) {</div>
<div class="line"><a name="l00206"></a><span class="lineno">  206</span>&#160;                    <span class="keywordflow">return</span> conn.InsertAll (items);</div>
<div class="line"><a name="l00207"></a><span class="lineno">  207</span>&#160;                }</div>
<div class="line"><a name="l00208"></a><span class="lineno">  208</span>&#160;            });</div>
<div class="line"><a name="l00209"></a><span class="lineno">  209</span>&#160;        }</div>
<div class="line"><a name="l00210"></a><span class="lineno">  210</span>&#160;</div>
<div class="line"><a name="l00211"></a><span class="lineno">  211</span>&#160;        [Obsolete(<span class="stringliteral">&quot;Will cause a deadlock if any call in action ends up in a different thread. Use RunInTransactionAsync(Action&lt;SQLiteConnection&gt;) instead.&quot;</span>)]</div>
<div class="line"><a name="l00212"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#affd521039f3a7da49746af600522c809">  212</a></span>&#160;        <span class="keyword">public</span> Task <a class="code" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#affd521039f3a7da49746af600522c809">RunInTransactionAsync</a> (Action&lt;SQLiteAsyncConnection&gt; action)</div>
<div class="line"><a name="l00213"></a><span class="lineno">  213</span>&#160;        {</div>
<div class="line"><a name="l00214"></a><span class="lineno">  214</span>&#160;            <span class="keywordflow">return</span> Task.Factory.StartNew (() =&gt; {</div>
<div class="line"><a name="l00215"></a><span class="lineno">  215</span>&#160;                var conn = this.GetConnection ();</div>
<div class="line"><a name="l00216"></a><span class="lineno">  216</span>&#160;                <span class="keyword">using</span> (conn.Lock ()) {</div>
<div class="line"><a name="l00217"></a><span class="lineno">  217</span>&#160;                    conn.BeginTransaction ();</div>
<div class="line"><a name="l00218"></a><span class="lineno">  218</span>&#160;                    <span class="keywordflow">try</span> {</div>
<div class="line"><a name="l00219"></a><span class="lineno">  219</span>&#160;                        action (<span class="keyword">this</span>);</div>
<div class="line"><a name="l00220"></a><span class="lineno">  220</span>&#160;                        conn.Commit ();</div>
<div class="line"><a name="l00221"></a><span class="lineno">  221</span>&#160;                    }</div>
<div class="line"><a name="l00222"></a><span class="lineno">  222</span>&#160;                    <span class="keywordflow">catch</span> (Exception) {</div>
<div class="line"><a name="l00223"></a><span class="lineno">  223</span>&#160;                        conn.Rollback ();</div>
<div class="line"><a name="l00224"></a><span class="lineno">  224</span>&#160;                        <span class="keywordflow">throw</span>;</div>
<div class="line"><a name="l00225"></a><span class="lineno">  225</span>&#160;                    }</div>
<div class="line"><a name="l00226"></a><span class="lineno">  226</span>&#160;                }</div>
<div class="line"><a name="l00227"></a><span class="lineno">  227</span>&#160;            });</div>
<div class="line"><a name="l00228"></a><span class="lineno">  228</span>&#160;        }</div>
<div class="line"><a name="l00229"></a><span class="lineno">  229</span>&#160;</div>
<div class="line"><a name="l00230"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a0d8abe01ee8f0afe93b6a38423d77029">  230</a></span>&#160;        <span class="keyword">public</span> Task <a class="code" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a0d8abe01ee8f0afe93b6a38423d77029">RunInTransactionAsync</a>(Action&lt;SQLiteConnection&gt; action)</div>
<div class="line"><a name="l00231"></a><span class="lineno">  231</span>&#160;        {</div>
<div class="line"><a name="l00232"></a><span class="lineno">  232</span>&#160;            <span class="keywordflow">return</span> Task.Factory.StartNew(() =&gt;</div>
<div class="line"><a name="l00233"></a><span class="lineno">  233</span>&#160;            {</div>
<div class="line"><a name="l00234"></a><span class="lineno">  234</span>&#160;                var conn = this.GetConnection();</div>
<div class="line"><a name="l00235"></a><span class="lineno">  235</span>&#160;                <span class="keyword">using</span> (conn.Lock())</div>
<div class="line"><a name="l00236"></a><span class="lineno">  236</span>&#160;                {</div>
<div class="line"><a name="l00237"></a><span class="lineno">  237</span>&#160;                    conn.BeginTransaction();</div>
<div class="line"><a name="l00238"></a><span class="lineno">  238</span>&#160;                    <span class="keywordflow">try</span></div>
<div class="line"><a name="l00239"></a><span class="lineno">  239</span>&#160;                    {</div>
<div class="line"><a name="l00240"></a><span class="lineno">  240</span>&#160;                        action(conn);</div>
<div class="line"><a name="l00241"></a><span class="lineno">  241</span>&#160;                        conn.Commit();</div>
<div class="line"><a name="l00242"></a><span class="lineno">  242</span>&#160;                    }</div>
<div class="line"><a name="l00243"></a><span class="lineno">  243</span>&#160;                    <span class="keywordflow">catch</span> (Exception)</div>
<div class="line"><a name="l00244"></a><span class="lineno">  244</span>&#160;                    {</div>
<div class="line"><a name="l00245"></a><span class="lineno">  245</span>&#160;                        conn.Rollback();</div>
<div class="line"><a name="l00246"></a><span class="lineno">  246</span>&#160;                        <span class="keywordflow">throw</span>;</div>
<div class="line"><a name="l00247"></a><span class="lineno">  247</span>&#160;                    }</div>
<div class="line"><a name="l00248"></a><span class="lineno">  248</span>&#160;                }</div>
<div class="line"><a name="l00249"></a><span class="lineno">  249</span>&#160;            });</div>
<div class="line"><a name="l00250"></a><span class="lineno">  250</span>&#160;        }</div>
<div class="line"><a name="l00251"></a><span class="lineno">  251</span>&#160;</div>
<div class="line"><a name="l00252"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#ae222dcdcc5033294c43c9cef1b16fbe1">  252</a></span>&#160;        <span class="keyword">public</span> <a class="code" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html">AsyncTableQuery&lt;T&gt;</a> <a class="code" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#ae222dcdcc5033294c43c9cef1b16fbe1">Table&lt;T&gt;</a> ()</div>
<div class="line"><a name="l00253"></a><span class="lineno">  253</span>&#160;            where T : <span class="keyword">new</span> ()</div>
<div class="line"><a name="l00254"></a><span class="lineno">  254</span>&#160;        {</div>
<div class="line"><a name="l00255"></a><span class="lineno">  255</span>&#160;            <span class="comment">//</span></div>
<div class="line"><a name="l00256"></a><span class="lineno">  256</span>&#160;            <span class="comment">// This isn&#39;t async as the underlying connection doesn&#39;t go out to the database</span></div>
<div class="line"><a name="l00257"></a><span class="lineno">  257</span>&#160;            <span class="comment">// until the query is performed. The Async methods are on the query iteself.</span></div>
<div class="line"><a name="l00258"></a><span class="lineno">  258</span>&#160;            <span class="comment">//</span></div>
<div class="line"><a name="l00259"></a><span class="lineno">  259</span>&#160;            var conn = GetConnection ();</div>
<div class="line"><a name="l00260"></a><span class="lineno">  260</span>&#160;            <span class="keywordflow">return</span> <span class="keyword">new</span> <a class="code" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html">AsyncTableQuery&lt;T&gt;</a> (conn.Table&lt;T&gt; ());</div>
<div class="line"><a name="l00261"></a><span class="lineno">  261</span>&#160;        }</div>
<div class="line"><a name="l00262"></a><span class="lineno">  262</span>&#160;</div>
<div class="line"><a name="l00263"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#adae67f753b244b754cc33be48cafbf67">  263</a></span>&#160;        <span class="keyword">public</span> Task&lt;T&gt; <a class="code" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#adae67f753b244b754cc33be48cafbf67">ExecuteScalarAsync&lt;T&gt;</a> (<span class="keywordtype">string</span> sql, params <span class="keywordtype">object</span>[] args)</div>
<div class="line"><a name="l00264"></a><span class="lineno">  264</span>&#160;        {</div>
<div class="line"><a name="l00265"></a><span class="lineno">  265</span>&#160;            <span class="keywordflow">return</span> Task&lt;T&gt;.Factory.StartNew (() =&gt; {</div>
<div class="line"><a name="l00266"></a><span class="lineno">  266</span>&#160;                var conn = GetConnection ();</div>
<div class="line"><a name="l00267"></a><span class="lineno">  267</span>&#160;                <span class="keyword">using</span> (conn.Lock ()) {</div>
<div class="line"><a name="l00268"></a><span class="lineno">  268</span>&#160;                    var command = conn.CreateCommand (sql, args);</div>
<div class="line"><a name="l00269"></a><span class="lineno">  269</span>&#160;                    <span class="keywordflow">return</span> command.ExecuteScalar&lt;T&gt; ();</div>
<div class="line"><a name="l00270"></a><span class="lineno">  270</span>&#160;                }</div>
<div class="line"><a name="l00271"></a><span class="lineno">  271</span>&#160;            });</div>
<div class="line"><a name="l00272"></a><span class="lineno">  272</span>&#160;        }</div>
<div class="line"><a name="l00273"></a><span class="lineno">  273</span>&#160;</div>
<div class="line"><a name="l00274"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a8a81a54a5769d761562d9a3ce18b0f57">  274</a></span>&#160;        <span class="keyword">public</span> Task&lt;List&lt;T&gt;&gt; <a class="code" href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a8a81a54a5769d761562d9a3ce18b0f57">QueryAsync&lt;T&gt;</a> (<span class="keywordtype">string</span> sql, params <span class="keywordtype">object</span>[] args)</div>
<div class="line"><a name="l00275"></a><span class="lineno">  275</span>&#160;            where T : <span class="keyword">new</span> ()</div>
<div class="line"><a name="l00276"></a><span class="lineno">  276</span>&#160;        {</div>
<div class="line"><a name="l00277"></a><span class="lineno">  277</span>&#160;            <span class="keywordflow">return</span> Task&lt;List&lt;T&gt;&gt;.Factory.StartNew (() =&gt; {</div>
<div class="line"><a name="l00278"></a><span class="lineno">  278</span>&#160;                var conn = GetConnection ();</div>
<div class="line"><a name="l00279"></a><span class="lineno">  279</span>&#160;                <span class="keyword">using</span> (conn.Lock ()) {</div>
<div class="line"><a name="l00280"></a><span class="lineno">  280</span>&#160;                    <span class="keywordflow">return</span> conn.Query&lt;T&gt; (sql, args);</div>
<div class="line"><a name="l00281"></a><span class="lineno">  281</span>&#160;                }</div>
<div class="line"><a name="l00282"></a><span class="lineno">  282</span>&#160;            });</div>
<div class="line"><a name="l00283"></a><span class="lineno">  283</span>&#160;        }</div>
<div class="line"><a name="l00284"></a><span class="lineno">  284</span>&#160;    }</div>
<div class="line"><a name="l00285"></a><span class="lineno">  285</span>&#160;</div>
<div class="line"><a name="l00286"></a><span class="lineno">  286</span>&#160;    <span class="comment">//</span></div>
<div class="line"><a name="l00287"></a><span class="lineno">  287</span>&#160;    <span class="comment">// TODO: Bind to AsyncConnection.GetConnection instead so that delayed</span></div>
<div class="line"><a name="l00288"></a><span class="lineno">  288</span>&#160;    <span class="comment">// execution can still work after a Pool.Reset.</span></div>
<div class="line"><a name="l00289"></a><span class="lineno">  289</span>&#160;    <span class="comment">//</span></div>
<div class="line"><a name="l00290"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html">  290</a></span>&#160;    <span class="keyword">public</span> <span class="keyword">class </span>AsyncTableQuery&lt;T&gt;</div>
<div class="line"><a name="l00291"></a><span class="lineno">  291</span>&#160;        where T : new ()</div>
<div class="line"><a name="l00292"></a><span class="lineno">  292</span>&#160;    {</div>
<div class="line"><a name="l00293"></a><span class="lineno">  293</span>&#160;        <a class="code" href="class_s_q_lite_1_1_table_query_3_01_t_01_4.html">TableQuery&lt;T&gt;</a> _innerQuery;</div>
<div class="line"><a name="l00294"></a><span class="lineno">  294</span>&#160;</div>
<div class="line"><a name="l00295"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html#a0255986ac768d5fca5b4e2c9840da35d">  295</a></span>&#160;        <span class="keyword">public</span> <a class="code" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html#a0255986ac768d5fca5b4e2c9840da35d">AsyncTableQuery</a> (<a class="code" href="class_s_q_lite_1_1_table_query_3_01_t_01_4.html">TableQuery&lt;T&gt;</a> innerQuery)</div>
<div class="line"><a name="l00296"></a><span class="lineno">  296</span>&#160;        {</div>
<div class="line"><a name="l00297"></a><span class="lineno">  297</span>&#160;            _innerQuery = innerQuery;</div>
<div class="line"><a name="l00298"></a><span class="lineno">  298</span>&#160;        }</div>
<div class="line"><a name="l00299"></a><span class="lineno">  299</span>&#160;</div>
<div class="line"><a name="l00300"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html#afe04f8363082a033b984230c7a245dea">  300</a></span>&#160;        <span class="keyword">public</span> <a class="code" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html">AsyncTableQuery&lt;T&gt;</a> <a class="code" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html#afe04f8363082a033b984230c7a245dea">Where</a> (Expression&lt;Func&lt;T, bool&gt;&gt; predExpr)</div>
<div class="line"><a name="l00301"></a><span class="lineno">  301</span>&#160;        {</div>
<div class="line"><a name="l00302"></a><span class="lineno">  302</span>&#160;            <span class="keywordflow">return</span> <span class="keyword">new</span> <a class="code" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html">AsyncTableQuery&lt;T&gt;</a> (_innerQuery.Where (predExpr));</div>
<div class="line"><a name="l00303"></a><span class="lineno">  303</span>&#160;        }</div>
<div class="line"><a name="l00304"></a><span class="lineno">  304</span>&#160;</div>
<div class="line"><a name="l00305"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html#ab1b8210413273abe6bc9383bc4f7ea9c">  305</a></span>&#160;        <span class="keyword">public</span> <a class="code" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html">AsyncTableQuery&lt;T&gt;</a> <a class="code" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html#ab1b8210413273abe6bc9383bc4f7ea9c">Skip</a> (<span class="keywordtype">int</span> n)</div>
<div class="line"><a name="l00306"></a><span class="lineno">  306</span>&#160;        {</div>
<div class="line"><a name="l00307"></a><span class="lineno">  307</span>&#160;            <span class="keywordflow">return</span> <span class="keyword">new</span> <a class="code" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html">AsyncTableQuery&lt;T&gt;</a> (_innerQuery.Skip (n));</div>
<div class="line"><a name="l00308"></a><span class="lineno">  308</span>&#160;        }</div>
<div class="line"><a name="l00309"></a><span class="lineno">  309</span>&#160;</div>
<div class="line"><a name="l00310"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html#a6c47c652b3b8123e2d4961263c289af9">  310</a></span>&#160;        <span class="keyword">public</span> <a class="code" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html">AsyncTableQuery&lt;T&gt;</a> <a class="code" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html#a6c47c652b3b8123e2d4961263c289af9">Take</a> (<span class="keywordtype">int</span> n)</div>
<div class="line"><a name="l00311"></a><span class="lineno">  311</span>&#160;        {</div>
<div class="line"><a name="l00312"></a><span class="lineno">  312</span>&#160;            <span class="keywordflow">return</span> <span class="keyword">new</span> <a class="code" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html">AsyncTableQuery&lt;T&gt;</a> (_innerQuery.Take (n));</div>
<div class="line"><a name="l00313"></a><span class="lineno">  313</span>&#160;        }</div>
<div class="line"><a name="l00314"></a><span class="lineno">  314</span>&#160;</div>
<div class="line"><a name="l00315"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html#a41540b08c3c49c123b57de8a0a5e3aea">  315</a></span>&#160;        <span class="keyword">public</span> <a class="code" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html">AsyncTableQuery&lt;T&gt;</a> OrderBy&lt;U&gt; (Expression&lt;Func&lt;T, U&gt;&gt; orderExpr)</div>
<div class="line"><a name="l00316"></a><span class="lineno">  316</span>&#160;        {</div>
<div class="line"><a name="l00317"></a><span class="lineno">  317</span>&#160;            <span class="keywordflow">return</span> <span class="keyword">new</span> <a class="code" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html">AsyncTableQuery&lt;T&gt;</a> (_innerQuery.OrderBy&lt;U&gt; (orderExpr));</div>
<div class="line"><a name="l00318"></a><span class="lineno">  318</span>&#160;        }</div>
<div class="line"><a name="l00319"></a><span class="lineno">  319</span>&#160;</div>
<div class="line"><a name="l00320"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html#a4a45b5c81ccf4459f17d66fba6a18c3f">  320</a></span>&#160;        <span class="keyword">public</span> <a class="code" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html">AsyncTableQuery&lt;T&gt;</a> OrderByDescending&lt;U&gt; (Expression&lt;Func&lt;T, U&gt;&gt; orderExpr)</div>
<div class="line"><a name="l00321"></a><span class="lineno">  321</span>&#160;        {</div>
<div class="line"><a name="l00322"></a><span class="lineno">  322</span>&#160;            <span class="keywordflow">return</span> <span class="keyword">new</span> <a class="code" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html">AsyncTableQuery&lt;T&gt;</a> (_innerQuery.OrderByDescending&lt;U&gt; (orderExpr));</div>
<div class="line"><a name="l00323"></a><span class="lineno">  323</span>&#160;        }</div>
<div class="line"><a name="l00324"></a><span class="lineno">  324</span>&#160;</div>
<div class="line"><a name="l00325"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html#a7343ff525af21bdc055935f46a39ae72">  325</a></span>&#160;        <span class="keyword">public</span> Task&lt;List&lt;T&gt;&gt; <a class="code" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html#a7343ff525af21bdc055935f46a39ae72">ToListAsync</a> ()</div>
<div class="line"><a name="l00326"></a><span class="lineno">  326</span>&#160;        {</div>
<div class="line"><a name="l00327"></a><span class="lineno">  327</span>&#160;            <span class="keywordflow">return</span> Task.Factory.StartNew (() =&gt; {</div>
<div class="line"><a name="l00328"></a><span class="lineno">  328</span>&#160;                <span class="keyword">using</span> (((<a class="code" href="class_s_q_lite_1_1_s_q_lite_connection_with_lock.html">SQLiteConnectionWithLock</a>)_innerQuery.Connection).Lock ()) {</div>
<div class="line"><a name="l00329"></a><span class="lineno">  329</span>&#160;                    <span class="keywordflow">return</span> _innerQuery.ToList ();</div>
<div class="line"><a name="l00330"></a><span class="lineno">  330</span>&#160;                }</div>
<div class="line"><a name="l00331"></a><span class="lineno">  331</span>&#160;            });</div>
<div class="line"><a name="l00332"></a><span class="lineno">  332</span>&#160;        }</div>
<div class="line"><a name="l00333"></a><span class="lineno">  333</span>&#160;</div>
<div class="line"><a name="l00334"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html#a70df4365834cfe29d0adb1c1841266b0">  334</a></span>&#160;        <span class="keyword">public</span> Task&lt;int&gt; <a class="code" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html#a70df4365834cfe29d0adb1c1841266b0">CountAsync</a> ()</div>
<div class="line"><a name="l00335"></a><span class="lineno">  335</span>&#160;        {</div>
<div class="line"><a name="l00336"></a><span class="lineno">  336</span>&#160;            <span class="keywordflow">return</span> Task.Factory.StartNew (() =&gt; {</div>
<div class="line"><a name="l00337"></a><span class="lineno">  337</span>&#160;                <span class="keyword">using</span> (((<a class="code" href="class_s_q_lite_1_1_s_q_lite_connection_with_lock.html">SQLiteConnectionWithLock</a>)_innerQuery.Connection).Lock ()) {</div>
<div class="line"><a name="l00338"></a><span class="lineno">  338</span>&#160;                    <span class="keywordflow">return</span> _innerQuery.Count ();</div>
<div class="line"><a name="l00339"></a><span class="lineno">  339</span>&#160;                }</div>
<div class="line"><a name="l00340"></a><span class="lineno">  340</span>&#160;            });</div>
<div class="line"><a name="l00341"></a><span class="lineno">  341</span>&#160;        }</div>
<div class="line"><a name="l00342"></a><span class="lineno">  342</span>&#160;</div>
<div class="line"><a name="l00343"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html#ade7303c76081c4b9cd80b4d25806ca30">  343</a></span>&#160;        <span class="keyword">public</span> Task&lt;T&gt; <a class="code" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html#ade7303c76081c4b9cd80b4d25806ca30">ElementAtAsync</a> (<span class="keywordtype">int</span> index)</div>
<div class="line"><a name="l00344"></a><span class="lineno">  344</span>&#160;        {</div>
<div class="line"><a name="l00345"></a><span class="lineno">  345</span>&#160;            <span class="keywordflow">return</span> Task.Factory.StartNew (() =&gt; {</div>
<div class="line"><a name="l00346"></a><span class="lineno">  346</span>&#160;                <span class="keyword">using</span> (((<a class="code" href="class_s_q_lite_1_1_s_q_lite_connection_with_lock.html">SQLiteConnectionWithLock</a>)_innerQuery.Connection).Lock ()) {</div>
<div class="line"><a name="l00347"></a><span class="lineno">  347</span>&#160;                    <span class="keywordflow">return</span> _innerQuery.ElementAt (index);</div>
<div class="line"><a name="l00348"></a><span class="lineno">  348</span>&#160;                }</div>
<div class="line"><a name="l00349"></a><span class="lineno">  349</span>&#160;            });</div>
<div class="line"><a name="l00350"></a><span class="lineno">  350</span>&#160;        }</div>
<div class="line"><a name="l00351"></a><span class="lineno">  351</span>&#160;</div>
<div class="line"><a name="l00352"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html#a2e3bae8cc7dc0b16abd95d4516d61971">  352</a></span>&#160;        <span class="keyword">public</span> Task&lt;T&gt; <a class="code" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html#a2e3bae8cc7dc0b16abd95d4516d61971">FirstAsync</a> ()</div>
<div class="line"><a name="l00353"></a><span class="lineno">  353</span>&#160;        {</div>
<div class="line"><a name="l00354"></a><span class="lineno">  354</span>&#160;            <span class="keywordflow">return</span> Task&lt;T&gt;.Factory.StartNew(() =&gt; {</div>
<div class="line"><a name="l00355"></a><span class="lineno">  355</span>&#160;                <span class="keyword">using</span> (((<a class="code" href="class_s_q_lite_1_1_s_q_lite_connection_with_lock.html">SQLiteConnectionWithLock</a>)_innerQuery.Connection).Lock ()) {</div>
<div class="line"><a name="l00356"></a><span class="lineno">  356</span>&#160;                    <span class="keywordflow">return</span> _innerQuery.First ();</div>
<div class="line"><a name="l00357"></a><span class="lineno">  357</span>&#160;                }</div>
<div class="line"><a name="l00358"></a><span class="lineno">  358</span>&#160;            });</div>
<div class="line"><a name="l00359"></a><span class="lineno">  359</span>&#160;        }</div>
<div class="line"><a name="l00360"></a><span class="lineno">  360</span>&#160;</div>
<div class="line"><a name="l00361"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html#aac82a5fa254a7f1c6a1a08f534989604">  361</a></span>&#160;        <span class="keyword">public</span> Task&lt;T&gt; <a class="code" href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html#aac82a5fa254a7f1c6a1a08f534989604">FirstOrDefaultAsync</a> ()</div>
<div class="line"><a name="l00362"></a><span class="lineno">  362</span>&#160;        {</div>
<div class="line"><a name="l00363"></a><span class="lineno">  363</span>&#160;            <span class="keywordflow">return</span> Task&lt;T&gt;.Factory.StartNew(() =&gt; {</div>
<div class="line"><a name="l00364"></a><span class="lineno">  364</span>&#160;                <span class="keyword">using</span> (((<a class="code" href="class_s_q_lite_1_1_s_q_lite_connection_with_lock.html">SQLiteConnectionWithLock</a>)_innerQuery.Connection).Lock ()) {</div>
<div class="line"><a name="l00365"></a><span class="lineno">  365</span>&#160;                    <span class="keywordflow">return</span> _innerQuery.FirstOrDefault ();</div>
<div class="line"><a name="l00366"></a><span class="lineno">  366</span>&#160;                }</div>
<div class="line"><a name="l00367"></a><span class="lineno">  367</span>&#160;            });</div>
<div class="line"><a name="l00368"></a><span class="lineno">  368</span>&#160;        }</div>
<div class="line"><a name="l00369"></a><span class="lineno">  369</span>&#160;    }</div>
<div class="line"><a name="l00370"></a><span class="lineno">  370</span>&#160;</div>
<div class="line"><a name="l00371"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_create_tables_result.html">  371</a></span>&#160;    <span class="keyword">public</span> <span class="keyword">class </span><a class="code" href="class_s_q_lite_1_1_create_tables_result.html">CreateTablesResult</a></div>
<div class="line"><a name="l00372"></a><span class="lineno">  372</span>&#160;    {</div>
<div class="line"><a name="l00373"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_create_tables_result.html#a570a918ea3d12d83f8dd1e2116c818c5">  373</a></span>&#160;        <span class="keyword">public</span> Dictionary&lt;Type, int&gt; <a class="code" href="class_s_q_lite_1_1_create_tables_result.html#a570a918ea3d12d83f8dd1e2116c818c5">Results</a> { <span class="keyword">get</span>; <span class="keyword">private</span> set; }</div>
<div class="line"><a name="l00374"></a><span class="lineno">  374</span>&#160;</div>
<div class="line"><a name="l00375"></a><span class="lineno">  375</span>&#160;        <span class="keyword">internal</span> <a class="code" href="class_s_q_lite_1_1_create_tables_result.html">CreateTablesResult</a> ()</div>
<div class="line"><a name="l00376"></a><span class="lineno">  376</span>&#160;        {</div>
<div class="line"><a name="l00377"></a><span class="lineno">  377</span>&#160;            this.Results = <span class="keyword">new</span> Dictionary&lt;Type, int&gt; ();</div>
<div class="line"><a name="l00378"></a><span class="lineno">  378</span>&#160;        }</div>
<div class="line"><a name="l00379"></a><span class="lineno">  379</span>&#160;    }</div>
<div class="line"><a name="l00380"></a><span class="lineno">  380</span>&#160;</div>
<div class="line"><a name="l00381"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_connection_pool.html">  381</a></span>&#160;    <span class="keyword">class </span><a class="code" href="class_s_q_lite_1_1_s_q_lite_connection_pool.html">SQLiteConnectionPool</a></div>
<div class="line"><a name="l00382"></a><span class="lineno">  382</span>&#160;    {</div>
<div class="line"><a name="l00383"></a><span class="lineno">  383</span>&#160;        <span class="keyword">class </span>Entry</div>
<div class="line"><a name="l00384"></a><span class="lineno">  384</span>&#160;        {</div>
<div class="line"><a name="l00385"></a><span class="lineno">  385</span>&#160;            <span class="keyword">public</span> <a class="code" href="class_s_q_lite_1_1_s_q_lite_connection_string.html">SQLiteConnectionString</a> ConnectionString { <span class="keyword">get</span>; <span class="keyword">private</span> set; }</div>
<div class="line"><a name="l00386"></a><span class="lineno">  386</span>&#160;            <span class="keyword">public</span> <a class="code" href="class_s_q_lite_1_1_s_q_lite_connection_with_lock.html">SQLiteConnectionWithLock</a> Connection { <span class="keyword">get</span>; <span class="keyword">private</span> set; }</div>
<div class="line"><a name="l00387"></a><span class="lineno">  387</span>&#160;</div>
<div class="line"><a name="l00388"></a><span class="lineno">  388</span>&#160;            <span class="keyword">public</span> Entry (<a class="code" href="class_s_q_lite_1_1_s_q_lite_connection_string.html">SQLiteConnectionString</a> connectionString)</div>
<div class="line"><a name="l00389"></a><span class="lineno">  389</span>&#160;            {</div>
<div class="line"><a name="l00390"></a><span class="lineno">  390</span>&#160;                ConnectionString = connectionString;</div>
<div class="line"><a name="l00391"></a><span class="lineno">  391</span>&#160;                Connection = <span class="keyword">new</span> <a class="code" href="class_s_q_lite_1_1_s_q_lite_connection_with_lock.html">SQLiteConnectionWithLock</a> (connectionString);</div>
<div class="line"><a name="l00392"></a><span class="lineno">  392</span>&#160;            }</div>
<div class="line"><a name="l00393"></a><span class="lineno">  393</span>&#160;</div>
<div class="line"><a name="l00394"></a><span class="lineno">  394</span>&#160;            <span class="keyword">public</span> <span class="keywordtype">void</span> OnApplicationSuspended ()</div>
<div class="line"><a name="l00395"></a><span class="lineno">  395</span>&#160;            {</div>
<div class="line"><a name="l00396"></a><span class="lineno">  396</span>&#160;                Connection.Dispose ();</div>
<div class="line"><a name="l00397"></a><span class="lineno">  397</span>&#160;                Connection = null;</div>
<div class="line"><a name="l00398"></a><span class="lineno">  398</span>&#160;            }</div>
<div class="line"><a name="l00399"></a><span class="lineno">  399</span>&#160;        }</div>
<div class="line"><a name="l00400"></a><span class="lineno">  400</span>&#160;</div>
<div class="line"><a name="l00401"></a><span class="lineno">  401</span>&#160;        readonly Dictionary&lt;string, Entry&gt; _entries = <span class="keyword">new</span> Dictionary&lt;string, Entry&gt; ();</div>
<div class="line"><a name="l00402"></a><span class="lineno">  402</span>&#160;        readonly <span class="keywordtype">object</span> _entriesLock = <span class="keyword">new</span> object ();</div>
<div class="line"><a name="l00403"></a><span class="lineno">  403</span>&#160;</div>
<div class="line"><a name="l00404"></a><span class="lineno">  404</span>&#160;        <span class="keyword">static</span> readonly <a class="code" href="class_s_q_lite_1_1_s_q_lite_connection_pool.html">SQLiteConnectionPool</a> _shared = <span class="keyword">new</span> <a class="code" href="class_s_q_lite_1_1_s_q_lite_connection_pool.html">SQLiteConnectionPool</a> ();</div>
<div class="line"><a name="l00405"></a><span class="lineno">  405</span>&#160;</div>
<div class="line"><a name="l00409"></a><span class="lineno">  409</span>&#160;        <span class="keyword">public</span> <span class="keyword">static</span> <a class="code" href="class_s_q_lite_1_1_s_q_lite_connection_pool.html">SQLiteConnectionPool</a> <a class="code" href="class_s_q_lite_1_1_s_q_lite_connection_pool.html#aaa23c37a087e3e04c4af6a69ce7cfb97">Shared</a></div>
<div class="line"><a name="l00410"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_connection_pool.html#aaa23c37a087e3e04c4af6a69ce7cfb97">  410</a></span>&#160;        {</div>
<div class="line"><a name="l00411"></a><span class="lineno">  411</span>&#160;            <span class="keyword">get</span></div>
<div class="line"><a name="l00412"></a><span class="lineno">  412</span>&#160;            {</div>
<div class="line"><a name="l00413"></a><span class="lineno">  413</span>&#160;                <span class="keywordflow">return</span> _shared;</div>
<div class="line"><a name="l00414"></a><span class="lineno">  414</span>&#160;            }</div>
<div class="line"><a name="l00415"></a><span class="lineno">  415</span>&#160;        }</div>
<div class="line"><a name="l00416"></a><span class="lineno">  416</span>&#160;</div>
<div class="line"><a name="l00417"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_connection_pool.html#a9998f3ae69bdc88b77827c03943492a5">  417</a></span>&#160;        <span class="keyword">public</span> <a class="code" href="class_s_q_lite_1_1_s_q_lite_connection_with_lock.html">SQLiteConnectionWithLock</a> <a class="code" href="class_s_q_lite_1_1_s_q_lite_connection_pool.html#a9998f3ae69bdc88b77827c03943492a5">GetConnection</a> (<a class="code" href="class_s_q_lite_1_1_s_q_lite_connection_string.html">SQLiteConnectionString</a> connectionString)</div>
<div class="line"><a name="l00418"></a><span class="lineno">  418</span>&#160;        {</div>
<div class="line"><a name="l00419"></a><span class="lineno">  419</span>&#160;            lock (_entriesLock) {</div>
<div class="line"><a name="l00420"></a><span class="lineno">  420</span>&#160;                Entry entry;</div>
<div class="line"><a name="l00421"></a><span class="lineno">  421</span>&#160;                <span class="keywordtype">string</span> key = connectionString.ConnectionString;</div>
<div class="line"><a name="l00422"></a><span class="lineno">  422</span>&#160;</div>
<div class="line"><a name="l00423"></a><span class="lineno">  423</span>&#160;                <span class="keywordflow">if</span> (!_entries.TryGetValue (key, out entry)) {</div>
<div class="line"><a name="l00424"></a><span class="lineno">  424</span>&#160;                    entry = <span class="keyword">new</span> Entry (connectionString);</div>
<div class="line"><a name="l00425"></a><span class="lineno">  425</span>&#160;                    _entries[key] = entry;</div>
<div class="line"><a name="l00426"></a><span class="lineno">  426</span>&#160;                }</div>
<div class="line"><a name="l00427"></a><span class="lineno">  427</span>&#160;</div>
<div class="line"><a name="l00428"></a><span class="lineno">  428</span>&#160;                <span class="keywordflow">return</span> entry.Connection;</div>
<div class="line"><a name="l00429"></a><span class="lineno">  429</span>&#160;            }</div>
<div class="line"><a name="l00430"></a><span class="lineno">  430</span>&#160;        }</div>
<div class="line"><a name="l00431"></a><span class="lineno">  431</span>&#160;</div>
<div class="line"><a name="l00435"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_connection_pool.html#a06bf58eb2050f2bb058c5bbfe76fab5e">  435</a></span>&#160;        <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="class_s_q_lite_1_1_s_q_lite_connection_pool.html#a06bf58eb2050f2bb058c5bbfe76fab5e">Reset</a> ()</div>
<div class="line"><a name="l00436"></a><span class="lineno">  436</span>&#160;        {</div>
<div class="line"><a name="l00437"></a><span class="lineno">  437</span>&#160;            lock (_entriesLock) {</div>
<div class="line"><a name="l00438"></a><span class="lineno">  438</span>&#160;                <span class="keywordflow">foreach</span> (var entry <span class="keywordflow">in</span> _entries.Values) {</div>
<div class="line"><a name="l00439"></a><span class="lineno">  439</span>&#160;                    entry.OnApplicationSuspended ();</div>
<div class="line"><a name="l00440"></a><span class="lineno">  440</span>&#160;                }</div>
<div class="line"><a name="l00441"></a><span class="lineno">  441</span>&#160;                _entries.Clear ();</div>
<div class="line"><a name="l00442"></a><span class="lineno">  442</span>&#160;            }</div>
<div class="line"><a name="l00443"></a><span class="lineno">  443</span>&#160;        }</div>
<div class="line"><a name="l00444"></a><span class="lineno">  444</span>&#160;</div>
<div class="line"><a name="l00449"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_connection_pool.html#a1ad83ea08efbe20c5f596d82977fffe9">  449</a></span>&#160;        <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="class_s_q_lite_1_1_s_q_lite_connection_pool.html#a1ad83ea08efbe20c5f596d82977fffe9">ApplicationSuspended</a> ()</div>
<div class="line"><a name="l00450"></a><span class="lineno">  450</span>&#160;        {</div>
<div class="line"><a name="l00451"></a><span class="lineno">  451</span>&#160;            <a class="code" href="class_s_q_lite_1_1_s_q_lite_connection_pool.html#a06bf58eb2050f2bb058c5bbfe76fab5e">Reset</a> ();</div>
<div class="line"><a name="l00452"></a><span class="lineno">  452</span>&#160;        }</div>
<div class="line"><a name="l00453"></a><span class="lineno">  453</span>&#160;    }</div>
<div class="line"><a name="l00454"></a><span class="lineno">  454</span>&#160;</div>
<div class="line"><a name="l00455"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_connection_with_lock.html">  455</a></span>&#160;    <span class="keyword">class </span><a class="code" href="class_s_q_lite_1_1_s_q_lite_connection_with_lock.html">SQLiteConnectionWithLock</a> : <a class="code" href="class_s_q_lite_1_1_s_q_lite_connection.html">SQLiteConnection</a></div>
<div class="line"><a name="l00456"></a><span class="lineno">  456</span>&#160;    {</div>
<div class="line"><a name="l00457"></a><span class="lineno">  457</span>&#160;        readonly <span class="keywordtype">object</span> _lockPoint = <span class="keyword">new</span> object ();</div>
<div class="line"><a name="l00458"></a><span class="lineno">  458</span>&#160;</div>
<div class="line"><a name="l00459"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_connection_with_lock.html#a49c8bfc343c53c30aa6195395958ffe2">  459</a></span>&#160;        <span class="keyword">public</span> <a class="code" href="class_s_q_lite_1_1_s_q_lite_connection_with_lock.html#a49c8bfc343c53c30aa6195395958ffe2">SQLiteConnectionWithLock</a> (<a class="code" href="class_s_q_lite_1_1_s_q_lite_connection_string.html">SQLiteConnectionString</a> connectionString)</div>
<div class="line"><a name="l00460"></a><span class="lineno">  460</span>&#160;            : base (connectionString.<a class="code" href="class_s_q_lite_1_1_s_q_lite_connection.html#a18b410ed380268c16bb9bdb47b5ad44b">DatabasePath</a>, connectionString.<a class="code" href="class_s_q_lite_1_1_s_q_lite_connection.html#a1c24728cf622f060629aac155e2afcaa">StoreDateTimeAsTicks</a>)</div>
<div class="line"><a name="l00461"></a><span class="lineno">  461</span>&#160;        {</div>
<div class="line"><a name="l00462"></a><span class="lineno">  462</span>&#160;        }</div>
<div class="line"><a name="l00463"></a><span class="lineno">  463</span>&#160;</div>
<div class="line"><a name="l00464"></a><span class="lineno"><a class="line" href="class_s_q_lite_1_1_s_q_lite_connection_with_lock.html#ad38e795a2b94ecd709b9b60e2c4d3e4e">  464</a></span>&#160;        <span class="keyword">public</span> IDisposable <a class="code" href="class_s_q_lite_1_1_s_q_lite_connection_with_lock.html#ad38e795a2b94ecd709b9b60e2c4d3e4e">Lock</a> ()</div>
<div class="line"><a name="l00465"></a><span class="lineno">  465</span>&#160;        {</div>
<div class="line"><a name="l00466"></a><span class="lineno">  466</span>&#160;            <span class="keywordflow">return</span> <span class="keyword">new</span> LockWrapper (_lockPoint);</div>
<div class="line"><a name="l00467"></a><span class="lineno">  467</span>&#160;        }</div>
<div class="line"><a name="l00468"></a><span class="lineno">  468</span>&#160;</div>
<div class="line"><a name="l00469"></a><span class="lineno">  469</span>&#160;        <span class="keyword">private</span> <span class="keyword">class </span>LockWrapper : IDisposable</div>
<div class="line"><a name="l00470"></a><span class="lineno">  470</span>&#160;        {</div>
<div class="line"><a name="l00471"></a><span class="lineno">  471</span>&#160;            <span class="keywordtype">object</span> _lockPoint;</div>
<div class="line"><a name="l00472"></a><span class="lineno">  472</span>&#160;</div>
<div class="line"><a name="l00473"></a><span class="lineno">  473</span>&#160;            <span class="keyword">public</span> LockWrapper (<span class="keywordtype">object</span> lockPoint)</div>
<div class="line"><a name="l00474"></a><span class="lineno">  474</span>&#160;            {</div>
<div class="line"><a name="l00475"></a><span class="lineno">  475</span>&#160;                _lockPoint = lockPoint;</div>
<div class="line"><a name="l00476"></a><span class="lineno">  476</span>&#160;                Monitor.Enter (_lockPoint);</div>
<div class="line"><a name="l00477"></a><span class="lineno">  477</span>&#160;            }</div>
<div class="line"><a name="l00478"></a><span class="lineno">  478</span>&#160;</div>
<div class="line"><a name="l00479"></a><span class="lineno">  479</span>&#160;            <span class="keyword">public</span> <span class="keywordtype">void</span> <a class="code" href="class_s_q_lite_1_1_s_q_lite_connection.html#ad9e1e281245e83dbe9c5303eaefe95f6">Dispose</a> ()</div>
<div class="line"><a name="l00480"></a><span class="lineno">  480</span>&#160;            {</div>
<div class="line"><a name="l00481"></a><span class="lineno">  481</span>&#160;                Monitor.Exit (_lockPoint);</div>
<div class="line"><a name="l00482"></a><span class="lineno">  482</span>&#160;            }</div>
<div class="line"><a name="l00483"></a><span class="lineno">  483</span>&#160;        }</div>
<div class="line"><a name="l00484"></a><span class="lineno">  484</span>&#160;    }</div>
<div class="line"><a name="l00485"></a><span class="lineno">  485</span>&#160;}</div>
<div class="line"><a name="l00486"></a><span class="lineno">  486</span>&#160;</div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_async_connection_html_ac34ee6c331f35dc8cbb73a0373315fb0"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_async_connection.html#ac34ee6c331f35dc8cbb73a0373315fb0">SQLite.SQLiteAsyncConnection.DeleteAsync</a></div><div class="ttdeci">Task&lt; int &gt; DeleteAsync(object item)</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00133">SQLiteAsync.cs:133</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_connection_with_lock_html"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_connection_with_lock.html">SQLite.SQLiteConnectionWithLock</a></div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00455">SQLiteAsync.cs:455</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_async_connection_html_af98ef3fd9628a9cda7b2b0532291f04b"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_async_connection.html#af98ef3fd9628a9cda7b2b0532291f04b">SQLite.SQLiteAsyncConnection.CreateTablesAsync</a></div><div class="ttdeci">Task&lt; CreateTablesResult &gt; CreateTablesAsync(params Type[] types)</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00087">SQLiteAsync.cs:87</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_connection_string_html"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_connection_string.html">SQLite.SQLiteConnectionString</a></div><div class="ttdoc">Represents a parsed connection string. </div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_8cs_source.html#l01300">SQLite.cs:1300</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_async_connection_html"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_async_connection.html">SQLite.SQLiteAsyncConnection</a></div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00033">SQLiteAsync.cs:33</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_async_connection_html_a120dc02c80780a01f9158aa2dc4110e3"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a120dc02c80780a01f9158aa2dc4110e3">SQLite.SQLiteAsyncConnection.CreateTableAsync&lt; T &gt;</a></div><div class="ttdeci">Task&lt; CreateTablesResult &gt; CreateTableAsync&lt; T &gt;()</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00047">SQLiteAsync.cs:47</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_connection_pool_html"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_connection_pool.html">SQLite.SQLiteConnectionPool</a></div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00381">SQLiteAsync.cs:381</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_async_connection_html_a59792569de902bd2e87b967a35154d4c"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a59792569de902bd2e87b967a35154d4c">SQLite.SQLiteAsyncConnection.GetAsync&lt; T &gt;</a></div><div class="ttdeci">Task&lt; T &gt; GetAsync&lt; T &gt;(object pk)</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00143">SQLiteAsync.cs:143</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_connection_pool_html_a9998f3ae69bdc88b77827c03943492a5"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_connection_pool.html#a9998f3ae69bdc88b77827c03943492a5">SQLite.SQLiteConnectionPool.GetConnection</a></div><div class="ttdeci">SQLiteConnectionWithLock GetConnection(SQLiteConnectionString connectionString)</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00417">SQLiteAsync.cs:417</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_async_connection_html_adae67f753b244b754cc33be48cafbf67"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_async_connection.html#adae67f753b244b754cc33be48cafbf67">SQLite.SQLiteAsyncConnection.ExecuteScalarAsync&lt; T &gt;</a></div><div class="ttdeci">Task&lt; T &gt; ExecuteScalarAsync&lt; T &gt;(string sql, params object[] args)</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00263">SQLiteAsync.cs:263</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_connection_pool_html_a1ad83ea08efbe20c5f596d82977fffe9"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_connection_pool.html#a1ad83ea08efbe20c5f596d82977fffe9">SQLite.SQLiteConnectionPool.ApplicationSuspended</a></div><div class="ttdeci">void ApplicationSuspended()</div><div class="ttdoc">Call this method when the application is suspended. </div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00449">SQLiteAsync.cs:449</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_async_connection_html_a3950c4feb7a8d2964a42167d8a4516a0"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a3950c4feb7a8d2964a42167d8a4516a0">SQLite.SQLiteAsyncConnection.UpdateAsync</a></div><div class="ttdeci">Task&lt; int &gt; UpdateAsync(object item)</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00123">SQLiteAsync.cs:123</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_connection_with_lock_html_a49c8bfc343c53c30aa6195395958ffe2"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_connection_with_lock.html#a49c8bfc343c53c30aa6195395958ffe2">SQLite.SQLiteConnectionWithLock.SQLiteConnectionWithLock</a></div><div class="ttdeci">SQLiteConnectionWithLock(SQLiteConnectionString connectionString)</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00459">SQLiteAsync.cs:459</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_async_connection_html_a1911c2250387bf7db96a05d4ab73bfe7"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a1911c2250387bf7db96a05d4ab73bfe7">SQLite.SQLiteAsyncConnection.CreateTablesAsync&lt; T, T2 &gt;</a></div><div class="ttdeci">Task&lt; CreateTablesResult &gt; CreateTablesAsync&lt; T, T2 &gt;()</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00053">SQLiteAsync.cs:53</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_create_tables_result_html"><div class="ttname"><a href="class_s_q_lite_1_1_create_tables_result.html">SQLite.CreateTablesResult</a></div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00371">SQLiteAsync.cs:371</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_async_connection_html_aa61f9b65944e23c32cac8b0e2c39d597"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_async_connection.html#aa61f9b65944e23c32cac8b0e2c39d597">SQLite.SQLiteAsyncConnection.ExecuteAsync</a></div><div class="ttdeci">Task&lt; int &gt; ExecuteAsync(string query, params object[] args)</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00191">SQLiteAsync.cs:191</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_connection_html_a1c24728cf622f060629aac155e2afcaa"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_connection.html#a1c24728cf622f060629aac155e2afcaa">SQLite.SQLiteConnection.StoreDateTimeAsTicks</a></div><div class="ttdeci">bool StoreDateTimeAsTicks</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_8cs_source.html#l00100">SQLite.cs:100</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_async_connection_html_a0d18028757d84c1d5ef6b4f0a2f31bf8"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a0d18028757d84c1d5ef6b4f0a2f31bf8">SQLite.SQLiteAsyncConnection.CreateTablesAsync&lt; T, T2, T3 &gt;</a></div><div class="ttdeci">Task&lt; CreateTablesResult &gt; CreateTablesAsync&lt; T, T2, T3 &gt;()</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00060">SQLiteAsync.cs:60</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_async_connection_html_a7c621805c4f3185e9b064288b2b47d4a"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a7c621805c4f3185e9b064288b2b47d4a">SQLite.SQLiteAsyncConnection.InsertAsync</a></div><div class="ttdeci">Task&lt; int &gt; InsertAsync(object item)</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00113">SQLiteAsync.cs:113</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_connection_with_lock_html_ad38e795a2b94ecd709b9b60e2c4d3e4e"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_connection_with_lock.html#ad38e795a2b94ecd709b9b60e2c4d3e4e">SQLite.SQLiteConnectionWithLock.Lock</a></div><div class="ttdeci">IDisposable Lock()</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00464">SQLiteAsync.cs:464</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_async_table_query_3_01_t_01_4_html_a70df4365834cfe29d0adb1c1841266b0"><div class="ttname"><a href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html#a70df4365834cfe29d0adb1c1841266b0">SQLite.AsyncTableQuery&lt; T &gt;.CountAsync</a></div><div class="ttdeci">Task&lt; int &gt; CountAsync()</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00334">SQLiteAsync.cs:334</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_async_table_query_3_01_t_01_4_html_ade7303c76081c4b9cd80b4d25806ca30"><div class="ttname"><a href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html#ade7303c76081c4b9cd80b4d25806ca30">SQLite.AsyncTableQuery&lt; T &gt;.ElementAtAsync</a></div><div class="ttdeci">Task&lt; T &gt; ElementAtAsync(int index)</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00343">SQLiteAsync.cs:343</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_table_query_3_01_t_01_4_html"><div class="ttname"><a href="class_s_q_lite_1_1_table_query_3_01_t_01_4.html">SQLite.TableQuery&lt; T &gt;</a></div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_8cs_source.html#l02100">SQLite.cs:2100</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_async_table_query_3_01_t_01_4_html_aac82a5fa254a7f1c6a1a08f534989604"><div class="ttname"><a href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html#aac82a5fa254a7f1c6a1a08f534989604">SQLite.AsyncTableQuery&lt; T &gt;.FirstOrDefaultAsync</a></div><div class="ttdeci">Task&lt; T &gt; FirstOrDefaultAsync()</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00361">SQLiteAsync.cs:361</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_connection_pool_html_a06bf58eb2050f2bb058c5bbfe76fab5e"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_connection_pool.html#a06bf58eb2050f2bb058c5bbfe76fab5e">SQLite.SQLiteConnectionPool.Reset</a></div><div class="ttdeci">void Reset()</div><div class="ttdoc">Closes all connections managed by this pool. </div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00435">SQLiteAsync.cs:435</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_create_tables_result_html_a570a918ea3d12d83f8dd1e2116c818c5"><div class="ttname"><a href="class_s_q_lite_1_1_create_tables_result.html#a570a918ea3d12d83f8dd1e2116c818c5">SQLite.CreateTablesResult.Results</a></div><div class="ttdeci">Dictionary&lt; Type, int &gt; Results</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00373">SQLiteAsync.cs:373</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_async_connection_html_a6b26a70d833ede366339dcdf0ac4ddec"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a6b26a70d833ede366339dcdf0ac4ddec">SQLite.SQLiteAsyncConnection.SQLiteAsyncConnection</a></div><div class="ttdeci">SQLiteAsyncConnection(string databasePath, bool storeDateTimeAsTicks=false)</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00037">SQLiteAsync.cs:37</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_connection_html"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_connection.html">SQLite.SQLiteConnection</a></div><div class="ttdoc">Represents an open connection to a SQLite database. </div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_8cs_source.html#l00079">SQLite.cs:79</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_async_table_query_3_01_t_01_4_html_a0255986ac768d5fca5b4e2c9840da35d"><div class="ttname"><a href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html#a0255986ac768d5fca5b4e2c9840da35d">SQLite.AsyncTableQuery&lt; T &gt;.AsyncTableQuery</a></div><div class="ttdeci">AsyncTableQuery(TableQuery&lt; T &gt; innerQuery)</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00295">SQLiteAsync.cs:295</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_connection_html_ad9e1e281245e83dbe9c5303eaefe95f6"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_connection.html#ad9e1e281245e83dbe9c5303eaefe95f6">SQLite.SQLiteConnection.Dispose</a></div><div class="ttdeci">void Dispose()</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_8cs_source.html#l01263">SQLite.cs:1263</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_async_connection_html_a6781339fb664cde6494460e686f5cb60"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a6781339fb664cde6494460e686f5cb60">SQLite.SQLiteAsyncConnection.DropTableAsync&lt; T &gt;</a></div><div class="ttdeci">Task&lt; int &gt; DropTableAsync&lt; T &gt;()</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00102">SQLiteAsync.cs:102</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_async_connection_html_a8a81a54a5769d761562d9a3ce18b0f57"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a8a81a54a5769d761562d9a3ce18b0f57">SQLite.SQLiteAsyncConnection.QueryAsync&lt; T &gt;</a></div><div class="ttdeci">Task&lt; List&lt; T &gt; &gt; QueryAsync&lt; T &gt;(string sql, params object[] args)</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00274">SQLiteAsync.cs:274</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_async_table_query_3_01_t_01_4_html_afe04f8363082a033b984230c7a245dea"><div class="ttname"><a href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html#afe04f8363082a033b984230c7a245dea">SQLite.AsyncTableQuery&lt; T &gt;.Where</a></div><div class="ttdeci">AsyncTableQuery&lt; T &gt; Where(Expression&lt; Func&lt; T, bool &gt;&gt; predExpr)</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00300">SQLiteAsync.cs:300</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_async_connection_html_a0d8abe01ee8f0afe93b6a38423d77029"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a0d8abe01ee8f0afe93b6a38423d77029">SQLite.SQLiteAsyncConnection.RunInTransactionAsync</a></div><div class="ttdeci">Task RunInTransactionAsync(Action&lt; SQLiteConnection &gt; action)</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00230">SQLiteAsync.cs:230</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_async_connection_html_a8caf48d01bf96785143e71ee6a12b6a0"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a8caf48d01bf96785143e71ee6a12b6a0">SQLite.SQLiteAsyncConnection.InsertAllAsync</a></div><div class="ttdeci">Task&lt; int &gt; InsertAllAsync(IEnumerable items)</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00201">SQLiteAsync.cs:201</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_async_table_query_3_01_t_01_4_html"><div class="ttname"><a href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html">SQLite.AsyncTableQuery&lt; T &gt;</a></div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00290">SQLiteAsync.cs:290</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_async_table_query_3_01_t_01_4_html_ab1b8210413273abe6bc9383bc4f7ea9c"><div class="ttname"><a href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html#ab1b8210413273abe6bc9383bc4f7ea9c">SQLite.AsyncTableQuery&lt; T &gt;.Skip</a></div><div class="ttdeci">AsyncTableQuery&lt; T &gt; Skip(int n)</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00305">SQLiteAsync.cs:305</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_connection_pool_html_aaa23c37a087e3e04c4af6a69ce7cfb97"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_connection_pool.html#aaa23c37a087e3e04c4af6a69ce7cfb97">SQLite.SQLiteConnectionPool.Shared</a></div><div class="ttdeci">static SQLiteConnectionPool Shared</div><div class="ttdoc">Gets the singleton instance of the connection tool. </div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00410">SQLiteAsync.cs:410</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_async_connection_html_a9b3c8584432d04508c89aebbbb1fedea"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a9b3c8584432d04508c89aebbbb1fedea">SQLite.SQLiteAsyncConnection.CreateTablesAsync&lt; T, T2, T3, T4, T5 &gt;</a></div><div class="ttdeci">Task&lt; CreateTablesResult &gt; CreateTablesAsync&lt; T, T2, T3, T4, T5 &gt;()</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00077">SQLiteAsync.cs:77</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_connection_html_a18b410ed380268c16bb9bdb47b5ad44b"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_connection.html#a18b410ed380268c16bb9bdb47b5ad44b">SQLite.SQLiteConnection.DatabasePath</a></div><div class="ttdeci">string DatabasePath</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_8cs_source.html#l00094">SQLite.cs:94</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_async_table_query_3_01_t_01_4_html_a6c47c652b3b8123e2d4961263c289af9"><div class="ttname"><a href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html#a6c47c652b3b8123e2d4961263c289af9">SQLite.AsyncTableQuery&lt; T &gt;.Take</a></div><div class="ttdeci">AsyncTableQuery&lt; T &gt; Take(int n)</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00310">SQLiteAsync.cs:310</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_async_connection_html_ae222dcdcc5033294c43c9cef1b16fbe1"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_async_connection.html#ae222dcdcc5033294c43c9cef1b16fbe1">SQLite.SQLiteAsyncConnection.Table&lt; T &gt;</a></div><div class="ttdeci">AsyncTableQuery&lt; T &gt; Table&lt; T &gt;()</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00252">SQLiteAsync.cs:252</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_async_connection_html_a36ed358566d4c64e0bf524c7d8c681a4"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a36ed358566d4c64e0bf524c7d8c681a4">SQLite.SQLiteAsyncConnection.CreateTablesAsync&lt; T, T2, T3, T4 &gt;</a></div><div class="ttdeci">Task&lt; CreateTablesResult &gt; CreateTablesAsync&lt; T, T2, T3, T4 &gt;()</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00068">SQLiteAsync.cs:68</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_async_table_query_3_01_t_01_4_html_a2e3bae8cc7dc0b16abd95d4516d61971"><div class="ttname"><a href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html#a2e3bae8cc7dc0b16abd95d4516d61971">SQLite.AsyncTableQuery&lt; T &gt;.FirstAsync</a></div><div class="ttdeci">Task&lt; T &gt; FirstAsync()</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00352">SQLiteAsync.cs:352</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_async_connection_html_a4e09e6aacf646853516ab1befea4ac4b"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_async_connection.html#a4e09e6aacf646853516ab1befea4ac4b">SQLite.SQLiteAsyncConnection.FindAsync&lt; T &gt;</a></div><div class="ttdeci">Task&lt; T &gt; FindAsync&lt; T &gt;(object pk)</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00156">SQLiteAsync.cs:156</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_s_q_lite_async_connection_html_affd521039f3a7da49746af600522c809"><div class="ttname"><a href="class_s_q_lite_1_1_s_q_lite_async_connection.html#affd521039f3a7da49746af600522c809">SQLite.SQLiteAsyncConnection.RunInTransactionAsync</a></div><div class="ttdeci">Task RunInTransactionAsync(Action&lt; SQLiteAsyncConnection &gt; action)</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00212">SQLiteAsync.cs:212</a></div></div>
<div class="ttc" id="class_s_q_lite_1_1_async_table_query_3_01_t_01_4_html_a7343ff525af21bdc055935f46a39ae72"><div class="ttname"><a href="class_s_q_lite_1_1_async_table_query_3_01_t_01_4.html#a7343ff525af21bdc055935f46a39ae72">SQLite.AsyncTableQuery&lt; T &gt;.ToListAsync</a></div><div class="ttdeci">Task&lt; List&lt; T &gt; &gt; ToListAsync()</div><div class="ttdef"><b>Definition:</b> <a href="_s_q_lite_async_8cs_source.html#l00325">SQLiteAsync.cs:325</a></div></div>
</div><!-- fragment --></div><!-- contents -->
</div><!-- doc-content -->
<!-- start footer part -->
<div id="nav-path" class="navpath"><!-- id is needed for treeview function! -->
  <ul>
    <li class="navelem"><a class="el" href="dir_bb5e995590685548b7e11478911ee7c3.html">SystemSharp-Google-SVN</a></li><li class="navelem"><a class="el" href="dir_8deefa4467a62b572b52d238d562b104.html">SystemSharp</a></li><li class="navelem"><a class="el" href="dir_7468bd2063bbdded308e1b920d17719d.html">XilinxSupportLib</a></li><li class="navelem"><a class="el" href="_s_q_lite_async_8cs.html">SQLiteAsync.cs</a></li>
    <li class="footer">Generated on Thu Dec 26 2013 14:21:43 for SystemSharp by
    <a href="http://www.doxygen.org/index.html">
    <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.8.6 </li>
  </ul>
</div>
</body>
</html>
